*************************************************************
Information on the data files provided for replication:
*************************************************************

------------------------------------------------------------------
!!! Please note the data statement at the end of this document !!!
------------------------------------------------------------------

The data folder archived at the IAB contains the following datasets representing the main individual, establishment and regional data.

List of datasets (variable lists for individual datasets further below):
***********************************************************************

Individual level data samples:

L_01_prepdata_v8_sample.dta			// Main individual analysis sample (variable list, see below)
L_01_prepdata_v11_sample.dta			// Alternative individual analysis sample (additional workers in 60-65 age bracket)
L_01_prepdata_v12_sample.dta			// Alternative individual analysis sample (keeping lowest paying job per worker)
L_01_prepdata_v13_sample.dta			// Alternative individual analysis sample (only apprentices)
L_01_prepdata_v14_sample.dta			// Alternative individual analysis sample (as v8, but t-1 logic)

Individual level data anonymized identifiers:

L_pers-base-prep_pers.dta			// List of anonymized person IDs in main individual analysis sample
L_pers-base-v11-prep_pers.dta			// List of anonymized person IDs in main alternative analysis sample v11
L_pers-base-v12-prep_pers.dta			// List of anonymized person IDs in main alternative analysis sample v12
L_pers-base-v13-prep_pers.dta			// List of anonymized person IDs in main alternative analysis sample v13
L_pers-base-v14-prep_pers.dta			// List of anonymized person IDs in main alternative analysis sample v14

Individual level data outcome variables for main sample (v8) (based on full population):

L_pers-reall1-prep_outcomes.dta			// Reallocation analysis: change in establishment wage, wage residual, size, high-skill share
						// lfdwage_d2_curr lfdwage_res_d2_curr lfsize_d2_curr shHS_d2_curr
L_pers-reall2-prep_outcomes.dta			// Reallocation analysis: change in establishment fulltime share, marginal share
						// shFT_d2_curr shMG_d2_curr
L_pers-reall4-prep_outcomes.dta			// Reallocation analysis: change in establishment turnover rate
						// turn2_d2_curr 
L_pers-reall6-prep_outcomes.dta			// Reallocation analysis: change in district wages and industry wages of establishment
						// lkdwage_d2_curr lidwage_d2_curr
L_pers-reall7-prep_outcomes.dta			// Reallocation analysis: change in establishment revenue per worker
						// ln_pw_rev_C_d2_curr
L_pers-reall8-prep_outcomes.dta			// Reallocation analysis: change in establishment affectedness
						// fblhw_d2_curr lfgap_hw_d2_curr
L_pers-reall9-prep_outcomes.dta			// Reallocation analysis: change in establishment wage residual not controlling for ft/pt/marginal employment status
						// lfdwage_res_d2_curr
L_pers-reall11-prep_outcomes.dta		// Reallocation analysis: change in establishment being in industry exempted from MW on Jan 1 2015
						// fexempt_d2_curr
L_pers-comm-prep_outcomes.dta			// Reallocation analysis: commuting (driving distance); all/male/female
						// drive_dist drive_dist_m drive_dist_f
L_pers-fe2-prep_outcomes.dta			// Reallocation analysis: change in establishment fixed effect
						// lFFE_d2_curr lFFE_imp_d2_curr
L_pers-fmob-prep_outcomes.dta			// Reallocation analysis: establishment mobility
						// fmob fmob_nf
L_pers-poach-prep_outcomes.dta			// Reallocation analysis: change in establishment poaching index
						// p_poach_d2_curr poach_d2_curr
L_pers-switch-prep_outcomes.dta			// Switcher analysis: Change in estabs average (residual) wage, average FE
						// lfdwage, LFFE

Individual level data outcome variables for alternative sample (v8+v11) (based on full population); x10:

L_pers-reall1-x10-prep_outcomes.dta		// outcomes, see above
L_pers-reall4-x10-prep_outcomes.dta
L_pers-reall7-x10-prep_outcomes.dta
L_pers-fe2-x10-prep_outcomes.dta

Individual level data outcome variables for alternative sample (v12) (based on full population); x11:

L_pers-reall1-x11-prep_outcomes.dta		// outcomes, see above
L_pers-reall4-x11-prep_outcomes.dta
L_pers-reall7-x11-prep_outcomes.dta
L_pers-fe2-x11-prep_outcomes.dta

Individual level data outcome variables for main sample (v8), but dropping industries exempted from MW (based on full population); x13:

L_pers-reall1-x13-prep_outcomes.dta		// outcomes, see above
L_pers-reall4-x13-prep_outcomes.dta
L_pers-reall7-x13-prep_outcomes.dta
L_pers-fe2-x13-prep_outcomes.dta

Individual level data outcome variables for alternative sample (v14) (based on full population); x14:

L_pers-reall1-x14-prep_outcomes.dta		// outcomes, see above
L_pers-reall4-x14-prep_outcomes.dta
L_pers-reall7-x14-prep_outcomes.dta
L_pers-fe2-x14-prep_outcomes.dta

Establishment level data samples:

L_estab_base_sample.dta				// Main establishment analysis sample (variable list, see below)

Regional level data:

L_02_agg-dis_v5.dta				// Main district analysis dataset (variable list, see below)
L_02_agg-dis-close_v5_locyear.dta		// Additional district variable: establishment closures, N_fclose1_2
L_02_agg-dis-estex_v5_locyear.dta		// Additional district variable: establishment count and size, N_firms, M_firmsize_trunc500
L_02_agg-dis_revpw_v5.dta			// Additional district variable: revenue per worker, pw_rev_worker
L_02_agg-dis_corrFE_v5_locyear.dta		// Additional district variable: correlation measure for FE, corr_FE

L_02_agg-dis_v6.dta				// Same as above, bot for functional labor market regions
L_02_agg-dis_revpw_v5_ram.dta			// ...
L_02_agg-dis_v6.dta				// ...
L_02_agg-dis-close_v6_locyear.dta		// ...
L_02_agg-dis-estex_v6_locyear.dta		// ...

Other data:

13211-0001.xlsx					// German statistical office data on unemployment rate
13311-0001.xlsx					// German statistical office data on employment
81000-0001.xlsx					// German statistical office data on nominal GDP
Figure_1.dta					// Collects data from German statistical office data above for convenience
L_pers-base-c_x9-clloc_dLUR_1611.dta		// Indicator for districts with stable/unstable unemployment rates 
L_pers-base-c_x15-clloc_hidisgap.dta		// Indicator for districts with MW affectedness above/below median
L_pers-distrib-prep.dta				// Bins of wage distribution for Figure A3
tradability_dauthetal_w08_3.dta			// Tradability index for industries, see prepare_dauthetal_tradedata.do in "preprocessing"
Tradedata_reshape_w93_3.dta			// Industry classification switch
map						// Map data from BKG for Germany


***************
Variable lists:
***************

L_01_prepdata_v8_sample.dta
---------------------------

(same varlist for L_01_prepdata_v11_sample.dta, L_01_prepdata_v12_sample.dta, L_01_prepdata_v13_sample.dta, L_01_prepdata_v14_sample.dta)

----------------------------------------------------------------------------------------------------------------------------
              storage   display    value
variable name   type    format     label      variable label
----------------------------------------------------------------------------------------------------------------------------
pers            long    %12.0g                Person ID
betnr           long    %12.0g                Establishment ID
sex             byte    %17.0g     gende      Gender
age             byte    %8.0g                 Age
nation_gr       byte    %24.0f     nat...     Nationality (agg.)
pgr_inc         byte    %8.0g                 Indicator: Person group inconsistent over time
pgr101          byte    %9.0g                 Indicator: Regular covered employment
emp_cat_imp     byte    %12.0g     emp_cat    employment category aggregated
educ_imp        byte    %9.0g      educ_imp   education level, imputed from all sources
afn             byte    %17.0g     afn_en     Demand level of current job
w08_5           long    %213.0f    w08_5_de   Wirtschaftsunterklasse 08 (5 digit industry code)
loc             int     %40.0f     ao_kre...  District (all sources combined)
beh_arbstd_imp  float   %9.0g                 Corrected working hours; full spell
beh_cens        byte    %9.0g                 Original average daily wage top-coded
tradable1       byte    %9.0g                 Tradable: Value of Exports in industry 1995>149 Billion Euros
beh_dur         int     %9.0g                 Duration of current BEH spell
empFTE          float   %9.0g                 Indicator: fulltime=1, parttime=0.5, minijob=0.2
emp             byte    %9.0g                 Indicator: employed
hwage           float   %9.0g                 Hourly wage
blhw            byte    %9.0g                 Indicator: Paid below minimum wage
emphw           byte    %9.0g                 Indicator: employed with non-missing hourly wage information
empFTEhw        float   %9.0g                 Indicator: fulltime=1, parttime=0.5, minijob=0.2, missing if no hourly wage observed
dwage           float   %9.0g                 Daily wage
bldw            byte    %9.0g                 Indicator: daily wage<MW*5.28 for FT; <MW*3.3 for PT; <MW*1.18 for Mini
empdw           byte    %9.0g                 Indicator: employed with non-missing daily wage information
empFTEdw        float   %9.0g                 Indicator: fulltime=1, parttime=0.5, minijob=0.2, missing if no daily wage observed
hdwage          float   %9.0g                 Hourly wage proxied from daily wage and ft/pt/marginal information
unemp           byte    %9.0g                 Indicator: unemployed
njobs           byte    %9.0g                 Number of jobs in current month
year            int     %9.0g                 Year
fsize           float   %9.0g                 Total number of employees in establishment
----------------------------------------------------------------------------------------------------------------------------

L_estab_base_sample.dta	
-----------------------
                         
----------------------------------------------------------------------------------------------------------------------------
              storage   display    value
variable name   type    format     label      variable label
----------------------------------------------------------------------------------------------------------------------------
betnr           long    %12.0g                Establishment ID
year            int     %9.0g                 Year
obsblhw         long    %9.0g                 Worker total relevant for 'blhw'
blhw            int     %9.0g                 Worker count below minimum
emp             long    %9.0g                 Establishment size (head count)
gapsum          double  %9.0g                 Total sum of wage gap
hwagesum        double  %9.0g                 Total sum of hourly wages (capped at SSC limit)
loc             int     %40.0f                District
w08_1           byte    %20.0f                1-digit industry group
gap             float   %9.0g                 Average wage gap
hdwage          float   %9.0g                 Average hourly wage, calculated from average daily wage
dwage           float   %9.0g                 Average daily wage
hwage           float   %9.0g                 Average hourly wage
----------------------------------------------------------------------------------------------------------------------------

L_02_agg-dis_v5.dta
-------------------

(same varlist for L_02_agg-dis_v6.dta)
                        
----------------------------------------------------------------------------------------------------------------------------
              storage   display    value
variable name   type    format     label      variable label
----------------------------------------------------------------------------------------------------------------------------
loc             int     %40.0f     ao_kreis   District
year            int     %9.0g                 Year
hdwage_trunc    float   %9.0g                 Average hourly wage, calculated from average daily wage, truncated at SSC ceiling
sumhwage_trunc  double  %9.0g                 Total hourly wage sum, truncated at SSC ceiling 
N_firms_t_size1 long    %12.0g                Number of establishments in size group: 1-2
N_pers_t_size1  long    %12.0g                Number of workers in establishments size group: 1-2
N_firms_t_size2 int     %12.0g                Number of establishments in size group: 3-4
N_pers_t_size2  long    %12.0g                Number of workers in establishments size group: 3-4
N_firms_t_size3 int     %12.0g                Number of establishments in size group: 5-19
N_pers_t_size3  long    %12.0g                Number of workers in establishments size group: 5-19
N_firms_t_size4 int     %12.0g                Number of establishments in size group: 20-49
N_pers_t_size4  long    %12.0g                Number of workers in establishments size group: 20-49
N_firms_t_size5 int     %12.0g                Number of establishments in size group: 50-99
N_pers_t_size5  long    %12.0g                Number of workers in establishments size group: 50-99
N_firms_t_size6 int     %12.0g                Number of establishments in size group: 100+
N_pers_t_size6  long    %12.0g                Number of workers in establishments size group: 100+
emp_a1          long    %9.0g                 Total employment age group [19,24]
emp_a2          long    %9.0g                 Total employment age group [25,34]
emp_a3          long    %9.0g                 Total employment age group [35,44]
emp_a4          long    %9.0g                 Total employment age group [45,59]
emp_fn          long    %9.0g                 Total employment foreigners
emp_i1          int     %9.0g                 Total employment Sections A/B according to WZ 08
emp_i2          long    %9.0g                 Total employment Sections C/E according to WZ 08
emp_i3          long    %9.0g                 Total employment Sections F/G according to WZ 08
emp_i4          long    %9.0g                 Total employment Sections H/I according to WZ 08
emp_i5          long    %9.0g                 Total employment Sections J/L according to WZ 08
emp_i6          long    %9.0g                 Total employment Sections M/N according to WZ 08
emp_i7          long    %9.0g                 Total employment Sections O/Q according to WZ 08
emp_i8          long    %9.0g                 Total employment Sections R/U according to WZ 08
emp_ls          long    %9.0g                 Total employment, low-skilled
emp_ms          long    %9.0g                 Total employment, medium-skilled
emp_hs          long    %9.0g                 Total employment, high-skilled
emp_em          long    %9.0g                 Total employment, missing skill
emp             long    %9.0g                 Total employment
unemp           long    %9.0g                 Total unemployment
blhw            long    %9.0g                 Total worker count earning below MW
emphw           long    %9.0g                 Total worker count with valid hourly wage info
sumgaph         double  %9.0g                 Total hourly wage gap sum
gaph            float   %9.0g                 Average hourly wage gap
mean_FFE_7t_2   float   %9.0g                 Average weighted establishment Fixed Effect in t-2
----------------------------------------------------------------------------------------------------------------------------


************************************************************************************************************************************************
************************************************************************************************************************************************

***************
Data statement:
***************

The data outlined here are social data with administrative origin, which are processed and kept by IAB according to the German Social Code III. 
There are certain legal restrictions due to the protection of data privacy. The data contain sensitive information and therefore are subject to 
the confidentiality regulations of the German Social Code (Book I, Section 35, Paragraph 1). The data are held by the 
Institute for Employment Research (IAB), Regensburger Str. 104, D-90478 Nurnberg, iab@iab.de, phone: +49 911 1790. 
Our data, computer programs, and results have been archived by the IAB to meet the objective of good scientific practice. This also extends to all
data that cannot be shared in this replication package. If you wish to access the data for replication purposes, please contact the authors or the IAB. 
Contact: e-mail philipp.vom-berge@iab.do or matthias.umkehrer@iab.de.

Note that due to the confidentiality of the data, access for replication purposes is restricted and only possible on-site at the IAB. 
Access can only be granted after successful application and approval. 